﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="details.aspx.vb" Inherits="WebApplication1.details1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <link href="Styles/DetailsStyle.css" rel="stylesheet" type="text/css" />
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
   <br />
   <br />
        <br />
        <br />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataKeyNames="ID" DataSourceID="SqlDataSource1" AllowSorting="True" CssClass="detailsgv" >
            <Columns>
                <asp:BoundField DataField="Skin_Care_Center_Name" 
                    HeaderText="Skin_Care_Center_Name" SortExpression="Skin_Care_Center_Name" />
                <asp:BoundField DataField="Postcode" HeaderText="Postcode" 
                    SortExpression="Postcode" />
                <asp:BoundField DataField="Skin_Care_Physician" 
                    HeaderText="Skin_Care_Physician" SortExpression="Skin_Care_Physician" />
                <asp:BoundField DataField="Physician_Details" HeaderText="Physician_Details" 
                    SortExpression="Physician_Details" />
                <asp:BoundField DataField="Consult_fee" HeaderText="Consult_fee" 
                    SortExpression="Consult_fee" />
                <asp:BoundField DataField="Rating_Stars" HeaderText="Rating_Stars" 
                    SortExpression="Rating_Stars" />
                <asp:BoundField DataField="Phone_Number" HeaderText="Phone_Number" 
                    SortExpression="Phone_Number" />
                <asp:ImageField DataImageUrlField="Care_Center_Images" HeaderText="Thumbnail">
                    <ControlStyle CssClass="skincare" width="100px" Height="100px"/>
                </asp:ImageField>
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SkinConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:SkinConnectionString.ProviderName %>" 
            SelectCommand="SELECT [ID], [Skin Care Center Name] AS Skin_Care_Center_Name, [Postcode], [Skin Care Physician] AS Skin_Care_Physician, [Physician Details] AS Physician_Details, [Care Center Images] AS Care_Center_Images, [Consult fee] AS Consult_fee, [Rating Stars] AS Rating_Stars, [Phone Number] AS Phone_Number FROM [skin care] WHERE ([ID] = ?)">
            <SelectParameters>
                <asp:QueryStringParameter Name="ID" QueryStringField="ID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br />
        <br />
        <br />
   
        <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" 
            DataSourceID="SqlDataSource2">
            <Columns>
                <asp:BoundField DataField="Skincaretips" HeaderText="Skincaretips" 
                    SortExpression="Skincaretips" />
                <asp:BoundField DataField="Imagetips" HeaderText="Imagetips" 
                    SortExpression="Imagetips" />
                <asp:BoundField DataField="skincare_fkid" HeaderText="skincare_fkid" 
                    SortExpression="skincare_fkid" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SkinConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:SkinConnectionString.ProviderName %>" 
            SelectCommand="SELECT [Skincaretips], [Imagetips], [skincare_fkid] FROM [tips] WHERE ([skincare_fkid] = ?)">
            <SelectParameters>
                <asp:QueryStringParameter Name="skincare_fkid" QueryStringField="ID" 
                    Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br />
        <br />
        <br />
 
        <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="False" 
            DataSourceID="SqlDataSource3">
            <Columns>
                <asp:BoundField DataField="username" HeaderText="username" 
                    SortExpression="username" />
                <asp:BoundField DataField="Feedback" HeaderText="Feedback" 
                    SortExpression="Feedback" />
                <asp:BoundField DataField="comment" HeaderText="comment" 
                    SortExpression="comment" />
                <asp:BoundField DataField="tips_fkid" HeaderText="tips_fkid" 
                    SortExpression="tips_fkid" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SkinConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:SkinConnectionString.ProviderName %>" 
            SelectCommand="SELECT [username], [Feedback], [comment], [tips_fkid] FROM [Feedback] WHERE ([tips_fkid] = ?)">
            <SelectParameters>
                <asp:QueryStringParameter Name="tips_fkid" QueryStringField="ID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br />
        <br />
        <br />
        <asp:CheckBoxList ID="cbl" runat="server" 
            DataSourceID="SqlDataSource4" DataTextField="Tagname" 
        DataValueField="ID" RepeatDirection="Horizontal">
        </asp:CheckBoxList>
        <asp:Button ID="tag" runat="server" Text="Tagskincare" />
 <br />Addnewtag   <asp:TextBox ID="tb2" runat="server"></asp:TextBox>
    <asp:Button
     ID="Addtag" runat="server" Text="Addtag" />
        <br />  
        <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SkinConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:SkinConnectionString.ProviderName %>" 
            SelectCommand="SELECT [Tagname], [ID] FROM [Tags]"></asp:SqlDataSource>
            <br />  
            <br /> 
        Skincaretips By physician<br /> 
        <br />   
    
               <asp:FileUpload ID="image" runat="server" />
               <br/>
               <br />  
               <br />  
               <br />  
   
        <asp:TextBox ID="t2" runat="server" Height="104px" TextMode="MultiLine" 
            Width="306px"></asp:TextBox>
            <br />
            <br />  
            <br />  
    
        <asp:Button ID="Ins" runat="server" Height="31px" Text="Instruction" 
            Width="106px" />
            <br />
            <br />  
            <br />  
            <br />  
    
       
        Username&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    
       
        <asp:TextBox ID="f1" runat="server" Height="27px" Width="156px"></asp:TextBox>
         <br />
         <br />  
         <br />         
        
        Feedback&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;       
        
        <asp:TextBox ID="f2" runat="server" Height="28px" Width="163px"></asp:TextBox>
        <br />  
        <br />  
        <br />  
 
        <asp:TextBox ID="f3" runat="server" Height="168px" style="margin-left: 0px" 
            TextMode="MultiLine" Width="424px"></asp:TextBox>
     <br />  
     <br />  
     <br />  
        <asp:Button ID="comment" runat="server" Height="26px" Text="AddComment" 
            Width="100px" />
  <br />  
  <br />  
</asp:Content>
